package weixinkeji.dev.power.center.so;

import sys.wx.ann.AF;
import weixinkeji.dev.power.center.bean.SysRP;
import weixinkeji.dev.power.center.bean.SysUP;

/**
 *
 * @author IK
 */
public class URPSQL {

    /**
     * 根据用户ID，查询用户权限
     */
    public static final String SELECT_UP_USERID = "SELECT * FROM " + AF.getTC(SysUP.class).talbeName + " WHERE user_id='?1'";
    
    /**
     * 根据角色ID，查询权限
     */
    public static final String SELECT_RP_USERID = "SELECT * FROM " + AF.getTC(SysRP.class).talbeName + " WHERE role_id='?1'";

    /**
     * 根据角色ID，查询角色权限 IN条件
     */
    public static final String SELECT_RP_ROLEID = "SELECT * FROM " + AF.getTC(SysRP.class).talbeName + " WHERE role_id IN (?1)";
    
    
}
